﻿



  
using System;
using SubSonic;
using SubSonic.Schema;
using SubSonic.DataProviders;
using System.Data;

namespace RingCast{
	public partial class RingCastDB{

        public StoredProcedure aspnet_AnyDataInTables(int TablesToCheck){
            StoredProcedure sp=new StoredProcedure("aspnet_AnyDataInTables",this.Provider);
            sp.Command.AddParameter("TablesToCheck",TablesToCheck,DbType.Int32);
            return sp;
        }
        public StoredProcedure aspnet_Applications_CreateApplication(string ApplicationName,Guid ApplicationId){
            StoredProcedure sp=new StoredProcedure("aspnet_Applications_CreateApplication",this.Provider);
            sp.Command.AddParameter("ApplicationName",ApplicationName,DbType.String);
            sp.Command.AddParameter("ApplicationId",ApplicationId,DbType.Guid);
            return sp;
        }
        public StoredProcedure aspnet_CheckSchemaVersion(string Feature,string CompatibleSchemaVersion){
            StoredProcedure sp=new StoredProcedure("aspnet_CheckSchemaVersion",this.Provider);
            sp.Command.AddParameter("Feature",Feature,DbType.String);
            sp.Command.AddParameter("CompatibleSchemaVersion",CompatibleSchemaVersion,DbType.String);
            return sp;
        }
        public StoredProcedure aspnet_Membership_ChangePasswordQuestionAndAnswer(string ApplicationName,string UserName,string NewPasswordQuestion,string NewPasswordAnswer){
            StoredProcedure sp=new StoredProcedure("aspnet_Membership_ChangePasswordQuestionAndAnswer",this.Provider);
            sp.Command.AddParameter("ApplicationName",ApplicationName,DbType.String);
            sp.Command.AddParameter("UserName",UserName,DbType.String);
            sp.Command.AddParameter("NewPasswordQuestion",NewPasswordQuestion,DbType.String);
            sp.Command.AddParameter("NewPasswordAnswer",NewPasswordAnswer,DbType.String);
            return sp;
        }
        public StoredProcedure aspnet_Membership_CreateUser(string ApplicationName,string UserName,string Password,string PasswordSalt,string Email,string PasswordQuestion,string PasswordAnswer,bool IsApproved,DateTime CurrentTimeUtc,DateTime CreateDate,int UniqueEmail,int PasswordFormat,Guid UserId){
            StoredProcedure sp=new StoredProcedure("aspnet_Membership_CreateUser",this.Provider);
            sp.Command.AddParameter("ApplicationName",ApplicationName,DbType.String);
            sp.Command.AddParameter("UserName",UserName,DbType.String);
            sp.Command.AddParameter("Password",Password,DbType.String);
            sp.Command.AddParameter("PasswordSalt",PasswordSalt,DbType.String);
            sp.Command.AddParameter("Email",Email,DbType.String);
            sp.Command.AddParameter("PasswordQuestion",PasswordQuestion,DbType.String);
            sp.Command.AddParameter("PasswordAnswer",PasswordAnswer,DbType.String);
            sp.Command.AddParameter("IsApproved",IsApproved,DbType.Boolean);
            sp.Command.AddParameter("CurrentTimeUtc",CurrentTimeUtc,DbType.DateTime);
            sp.Command.AddParameter("CreateDate",CreateDate,DbType.DateTime);
            sp.Command.AddParameter("UniqueEmail",UniqueEmail,DbType.Int32);
            sp.Command.AddParameter("PasswordFormat",PasswordFormat,DbType.Int32);
            sp.Command.AddParameter("UserId",UserId,DbType.Guid);
            return sp;
        }
        public StoredProcedure aspnet_Membership_FindUsersByEmail(string ApplicationName,string EmailToMatch,int PageIndex,int PageSize){
            StoredProcedure sp=new StoredProcedure("aspnet_Membership_FindUsersByEmail",this.Provider);
            sp.Command.AddParameter("ApplicationName",ApplicationName,DbType.String);
            sp.Command.AddParameter("EmailToMatch",EmailToMatch,DbType.String);
            sp.Command.AddParameter("PageIndex",PageIndex,DbType.Int32);
            sp.Command.AddParameter("PageSize",PageSize,DbType.Int32);
            return sp;
        }
        public StoredProcedure aspnet_Membership_FindUsersByName(string ApplicationName,string UserNameToMatch,int PageIndex,int PageSize){
            StoredProcedure sp=new StoredProcedure("aspnet_Membership_FindUsersByName",this.Provider);
            sp.Command.AddParameter("ApplicationName",ApplicationName,DbType.String);
            sp.Command.AddParameter("UserNameToMatch",UserNameToMatch,DbType.String);
            sp.Command.AddParameter("PageIndex",PageIndex,DbType.Int32);
            sp.Command.AddParameter("PageSize",PageSize,DbType.Int32);
            return sp;
        }
        public StoredProcedure aspnet_Membership_GetAllUsers(string ApplicationName,int PageIndex,int PageSize){
            StoredProcedure sp=new StoredProcedure("aspnet_Membership_GetAllUsers",this.Provider);
            sp.Command.AddParameter("ApplicationName",ApplicationName,DbType.String);
            sp.Command.AddParameter("PageIndex",PageIndex,DbType.Int32);
            sp.Command.AddParameter("PageSize",PageSize,DbType.Int32);
            return sp;
        }
        public StoredProcedure aspnet_Membership_GetNumberOfUsersOnline(string ApplicationName,int MinutesSinceLastInActive,DateTime CurrentTimeUtc){
            StoredProcedure sp=new StoredProcedure("aspnet_Membership_GetNumberOfUsersOnline",this.Provider);
            sp.Command.AddParameter("ApplicationName",ApplicationName,DbType.String);
            sp.Command.AddParameter("MinutesSinceLastInActive",MinutesSinceLastInActive,DbType.Int32);
            sp.Command.AddParameter("CurrentTimeUtc",CurrentTimeUtc,DbType.DateTime);
            return sp;
        }
        public StoredProcedure aspnet_Membership_GetPassword(string ApplicationName,string UserName,int MaxInvalidPasswordAttempts,int PasswordAttemptWindow,DateTime CurrentTimeUtc,string PasswordAnswer){
            StoredProcedure sp=new StoredProcedure("aspnet_Membership_GetPassword",this.Provider);
            sp.Command.AddParameter("ApplicationName",ApplicationName,DbType.String);
            sp.Command.AddParameter("UserName",UserName,DbType.String);
            sp.Command.AddParameter("MaxInvalidPasswordAttempts",MaxInvalidPasswordAttempts,DbType.Int32);
            sp.Command.AddParameter("PasswordAttemptWindow",PasswordAttemptWindow,DbType.Int32);
            sp.Command.AddParameter("CurrentTimeUtc",CurrentTimeUtc,DbType.DateTime);
            sp.Command.AddParameter("PasswordAnswer",PasswordAnswer,DbType.String);
            return sp;
        }
        public StoredProcedure aspnet_Membership_GetPasswordWithFormat(string ApplicationName,string UserName,bool UpdateLastLoginActivityDate,DateTime CurrentTimeUtc){
            StoredProcedure sp=new StoredProcedure("aspnet_Membership_GetPasswordWithFormat",this.Provider);
            sp.Command.AddParameter("ApplicationName",ApplicationName,DbType.String);
            sp.Command.AddParameter("UserName",UserName,DbType.String);
            sp.Command.AddParameter("UpdateLastLoginActivityDate",UpdateLastLoginActivityDate,DbType.Boolean);
            sp.Command.AddParameter("CurrentTimeUtc",CurrentTimeUtc,DbType.DateTime);
            return sp;
        }
        public StoredProcedure aspnet_Membership_GetUserByEmail(string ApplicationName,string Email){
            StoredProcedure sp=new StoredProcedure("aspnet_Membership_GetUserByEmail",this.Provider);
            sp.Command.AddParameter("ApplicationName",ApplicationName,DbType.String);
            sp.Command.AddParameter("Email",Email,DbType.String);
            return sp;
        }
        public StoredProcedure aspnet_Membership_GetUserByName(string ApplicationName,string UserName,DateTime CurrentTimeUtc,bool UpdateLastActivity){
            StoredProcedure sp=new StoredProcedure("aspnet_Membership_GetUserByName",this.Provider);
            sp.Command.AddParameter("ApplicationName",ApplicationName,DbType.String);
            sp.Command.AddParameter("UserName",UserName,DbType.String);
            sp.Command.AddParameter("CurrentTimeUtc",CurrentTimeUtc,DbType.DateTime);
            sp.Command.AddParameter("UpdateLastActivity",UpdateLastActivity,DbType.Boolean);
            return sp;
        }
        public StoredProcedure aspnet_Membership_GetUserByUserId(Guid UserId,DateTime CurrentTimeUtc,bool UpdateLastActivity){
            StoredProcedure sp=new StoredProcedure("aspnet_Membership_GetUserByUserId",this.Provider);
            sp.Command.AddParameter("UserId",UserId,DbType.Guid);
            sp.Command.AddParameter("CurrentTimeUtc",CurrentTimeUtc,DbType.DateTime);
            sp.Command.AddParameter("UpdateLastActivity",UpdateLastActivity,DbType.Boolean);
            return sp;
        }
        public StoredProcedure aspnet_Membership_ResetPassword(string ApplicationName,string UserName,string NewPassword,int MaxInvalidPasswordAttempts,int PasswordAttemptWindow,string PasswordSalt,DateTime CurrentTimeUtc,int PasswordFormat,string PasswordAnswer){
            StoredProcedure sp=new StoredProcedure("aspnet_Membership_ResetPassword",this.Provider);
            sp.Command.AddParameter("ApplicationName",ApplicationName,DbType.String);
            sp.Command.AddParameter("UserName",UserName,DbType.String);
            sp.Command.AddParameter("NewPassword",NewPassword,DbType.String);
            sp.Command.AddParameter("MaxInvalidPasswordAttempts",MaxInvalidPasswordAttempts,DbType.Int32);
            sp.Command.AddParameter("PasswordAttemptWindow",PasswordAttemptWindow,DbType.Int32);
            sp.Command.AddParameter("PasswordSalt",PasswordSalt,DbType.String);
            sp.Command.AddParameter("CurrentTimeUtc",CurrentTimeUtc,DbType.DateTime);
            sp.Command.AddParameter("PasswordFormat",PasswordFormat,DbType.Int32);
            sp.Command.AddParameter("PasswordAnswer",PasswordAnswer,DbType.String);
            return sp;
        }
        public StoredProcedure aspnet_Membership_SetPassword(string ApplicationName,string UserName,string NewPassword,string PasswordSalt,DateTime CurrentTimeUtc,int PasswordFormat){
            StoredProcedure sp=new StoredProcedure("aspnet_Membership_SetPassword",this.Provider);
            sp.Command.AddParameter("ApplicationName",ApplicationName,DbType.String);
            sp.Command.AddParameter("UserName",UserName,DbType.String);
            sp.Command.AddParameter("NewPassword",NewPassword,DbType.String);
            sp.Command.AddParameter("PasswordSalt",PasswordSalt,DbType.String);
            sp.Command.AddParameter("CurrentTimeUtc",CurrentTimeUtc,DbType.DateTime);
            sp.Command.AddParameter("PasswordFormat",PasswordFormat,DbType.Int32);
            return sp;
        }
        public StoredProcedure aspnet_Membership_UnlockUser(string ApplicationName,string UserName){
            StoredProcedure sp=new StoredProcedure("aspnet_Membership_UnlockUser",this.Provider);
            sp.Command.AddParameter("ApplicationName",ApplicationName,DbType.String);
            sp.Command.AddParameter("UserName",UserName,DbType.String);
            return sp;
        }
        public StoredProcedure aspnet_Membership_UpdateUser(string ApplicationName,string UserName,string Email,string Comment,bool IsApproved,DateTime LastLoginDate,DateTime LastActivityDate,int UniqueEmail,DateTime CurrentTimeUtc){
            StoredProcedure sp=new StoredProcedure("aspnet_Membership_UpdateUser",this.Provider);
            sp.Command.AddParameter("ApplicationName",ApplicationName,DbType.String);
            sp.Command.AddParameter("UserName",UserName,DbType.String);
            sp.Command.AddParameter("Email",Email,DbType.String);
            sp.Command.AddParameter("Comment",Comment,DbType.String);
            sp.Command.AddParameter("IsApproved",IsApproved,DbType.Boolean);
            sp.Command.AddParameter("LastLoginDate",LastLoginDate,DbType.DateTime);
            sp.Command.AddParameter("LastActivityDate",LastActivityDate,DbType.DateTime);
            sp.Command.AddParameter("UniqueEmail",UniqueEmail,DbType.Int32);
            sp.Command.AddParameter("CurrentTimeUtc",CurrentTimeUtc,DbType.DateTime);
            return sp;
        }
        public StoredProcedure aspnet_Membership_UpdateUserInfo(string ApplicationName,string UserName,bool IsPasswordCorrect,bool UpdateLastLoginActivityDate,int MaxInvalidPasswordAttempts,int PasswordAttemptWindow,DateTime CurrentTimeUtc,DateTime LastLoginDate,DateTime LastActivityDate){
            StoredProcedure sp=new StoredProcedure("aspnet_Membership_UpdateUserInfo",this.Provider);
            sp.Command.AddParameter("ApplicationName",ApplicationName,DbType.String);
            sp.Command.AddParameter("UserName",UserName,DbType.String);
            sp.Command.AddParameter("IsPasswordCorrect",IsPasswordCorrect,DbType.Boolean);
            sp.Command.AddParameter("UpdateLastLoginActivityDate",UpdateLastLoginActivityDate,DbType.Boolean);
            sp.Command.AddParameter("MaxInvalidPasswordAttempts",MaxInvalidPasswordAttempts,DbType.Int32);
            sp.Command.AddParameter("PasswordAttemptWindow",PasswordAttemptWindow,DbType.Int32);
            sp.Command.AddParameter("CurrentTimeUtc",CurrentTimeUtc,DbType.DateTime);
            sp.Command.AddParameter("LastLoginDate",LastLoginDate,DbType.DateTime);
            sp.Command.AddParameter("LastActivityDate",LastActivityDate,DbType.DateTime);
            return sp;
        }
        public StoredProcedure aspnet_Paths_CreatePath(Guid ApplicationId,string Path,Guid PathId){
            StoredProcedure sp=new StoredProcedure("aspnet_Paths_CreatePath",this.Provider);
            sp.Command.AddParameter("ApplicationId",ApplicationId,DbType.Guid);
            sp.Command.AddParameter("Path",Path,DbType.String);
            sp.Command.AddParameter("PathId",PathId,DbType.Guid);
            return sp;
        }
        public StoredProcedure aspnet_Personalization_GetApplicationId(string ApplicationName,Guid ApplicationId){
            StoredProcedure sp=new StoredProcedure("aspnet_Personalization_GetApplicationId",this.Provider);
            sp.Command.AddParameter("ApplicationName",ApplicationName,DbType.String);
            sp.Command.AddParameter("ApplicationId",ApplicationId,DbType.Guid);
            return sp;
        }
        public StoredProcedure aspnet_PersonalizationAdministration_DeleteAllState(bool AllUsersScope,string ApplicationName,int Count){
            StoredProcedure sp=new StoredProcedure("aspnet_PersonalizationAdministration_DeleteAllState",this.Provider);
            sp.Command.AddParameter("AllUsersScope",AllUsersScope,DbType.Boolean);
            sp.Command.AddParameter("ApplicationName",ApplicationName,DbType.String);
            sp.Command.AddParameter("Count",Count,DbType.Int32);
            return sp;
        }
        public StoredProcedure aspnet_PersonalizationAdministration_FindState(bool AllUsersScope,string ApplicationName,int PageIndex,int PageSize,string Path,string UserName,DateTime InactiveSinceDate){
            StoredProcedure sp=new StoredProcedure("aspnet_PersonalizationAdministration_FindState",this.Provider);
            sp.Command.AddParameter("AllUsersScope",AllUsersScope,DbType.Boolean);
            sp.Command.AddParameter("ApplicationName",ApplicationName,DbType.String);
            sp.Command.AddParameter("PageIndex",PageIndex,DbType.Int32);
            sp.Command.AddParameter("PageSize",PageSize,DbType.Int32);
            sp.Command.AddParameter("Path",Path,DbType.String);
            sp.Command.AddParameter("UserName",UserName,DbType.String);
            sp.Command.AddParameter("InactiveSinceDate",InactiveSinceDate,DbType.DateTime);
            return sp;
        }
        public StoredProcedure aspnet_PersonalizationAdministration_GetCountOfState(int Count,bool AllUsersScope,string ApplicationName,string Path,string UserName,DateTime InactiveSinceDate){
            StoredProcedure sp=new StoredProcedure("aspnet_PersonalizationAdministration_GetCountOfState",this.Provider);
            sp.Command.AddParameter("Count",Count,DbType.Int32);
            sp.Command.AddParameter("AllUsersScope",AllUsersScope,DbType.Boolean);
            sp.Command.AddParameter("ApplicationName",ApplicationName,DbType.String);
            sp.Command.AddParameter("Path",Path,DbType.String);
            sp.Command.AddParameter("UserName",UserName,DbType.String);
            sp.Command.AddParameter("InactiveSinceDate",InactiveSinceDate,DbType.DateTime);
            return sp;
        }
        public StoredProcedure aspnet_PersonalizationAdministration_ResetSharedState(int Count,string ApplicationName,string Path){
            StoredProcedure sp=new StoredProcedure("aspnet_PersonalizationAdministration_ResetSharedState",this.Provider);
            sp.Command.AddParameter("Count",Count,DbType.Int32);
            sp.Command.AddParameter("ApplicationName",ApplicationName,DbType.String);
            sp.Command.AddParameter("Path",Path,DbType.String);
            return sp;
        }
        public StoredProcedure aspnet_PersonalizationAdministration_ResetUserState(int Count,string ApplicationName,DateTime InactiveSinceDate,string UserName,string Path){
            StoredProcedure sp=new StoredProcedure("aspnet_PersonalizationAdministration_ResetUserState",this.Provider);
            sp.Command.AddParameter("Count",Count,DbType.Int32);
            sp.Command.AddParameter("ApplicationName",ApplicationName,DbType.String);
            sp.Command.AddParameter("InactiveSinceDate",InactiveSinceDate,DbType.DateTime);
            sp.Command.AddParameter("UserName",UserName,DbType.String);
            sp.Command.AddParameter("Path",Path,DbType.String);
            return sp;
        }
        public StoredProcedure aspnet_PersonalizationAllUsers_GetPageSettings(string ApplicationName,string Path){
            StoredProcedure sp=new StoredProcedure("aspnet_PersonalizationAllUsers_GetPageSettings",this.Provider);
            sp.Command.AddParameter("ApplicationName",ApplicationName,DbType.String);
            sp.Command.AddParameter("Path",Path,DbType.String);
            return sp;
        }
        public StoredProcedure aspnet_PersonalizationAllUsers_ResetPageSettings(string ApplicationName,string Path){
            StoredProcedure sp=new StoredProcedure("aspnet_PersonalizationAllUsers_ResetPageSettings",this.Provider);
            sp.Command.AddParameter("ApplicationName",ApplicationName,DbType.String);
            sp.Command.AddParameter("Path",Path,DbType.String);
            return sp;
        }
        public StoredProcedure aspnet_PersonalizationAllUsers_SetPageSettings(string ApplicationName,string Path,byte[] PageSettings,DateTime CurrentTimeUtc){
            StoredProcedure sp=new StoredProcedure("aspnet_PersonalizationAllUsers_SetPageSettings",this.Provider);
            sp.Command.AddParameter("ApplicationName",ApplicationName,DbType.String);
            sp.Command.AddParameter("Path",Path,DbType.String);
            sp.Command.AddParameter("PageSettings",PageSettings,DbType.Binary);
            sp.Command.AddParameter("CurrentTimeUtc",CurrentTimeUtc,DbType.DateTime);
            return sp;
        }
        public StoredProcedure aspnet_PersonalizationPerUser_GetPageSettings(string ApplicationName,string UserName,string Path,DateTime CurrentTimeUtc){
            StoredProcedure sp=new StoredProcedure("aspnet_PersonalizationPerUser_GetPageSettings",this.Provider);
            sp.Command.AddParameter("ApplicationName",ApplicationName,DbType.String);
            sp.Command.AddParameter("UserName",UserName,DbType.String);
            sp.Command.AddParameter("Path",Path,DbType.String);
            sp.Command.AddParameter("CurrentTimeUtc",CurrentTimeUtc,DbType.DateTime);
            return sp;
        }
        public StoredProcedure aspnet_PersonalizationPerUser_ResetPageSettings(string ApplicationName,string UserName,string Path,DateTime CurrentTimeUtc){
            StoredProcedure sp=new StoredProcedure("aspnet_PersonalizationPerUser_ResetPageSettings",this.Provider);
            sp.Command.AddParameter("ApplicationName",ApplicationName,DbType.String);
            sp.Command.AddParameter("UserName",UserName,DbType.String);
            sp.Command.AddParameter("Path",Path,DbType.String);
            sp.Command.AddParameter("CurrentTimeUtc",CurrentTimeUtc,DbType.DateTime);
            return sp;
        }
        public StoredProcedure aspnet_PersonalizationPerUser_SetPageSettings(string ApplicationName,string UserName,string Path,byte[] PageSettings,DateTime CurrentTimeUtc){
            StoredProcedure sp=new StoredProcedure("aspnet_PersonalizationPerUser_SetPageSettings",this.Provider);
            sp.Command.AddParameter("ApplicationName",ApplicationName,DbType.String);
            sp.Command.AddParameter("UserName",UserName,DbType.String);
            sp.Command.AddParameter("Path",Path,DbType.String);
            sp.Command.AddParameter("PageSettings",PageSettings,DbType.Binary);
            sp.Command.AddParameter("CurrentTimeUtc",CurrentTimeUtc,DbType.DateTime);
            return sp;
        }
        public StoredProcedure aspnet_Profile_DeleteInactiveProfiles(string ApplicationName,int ProfileAuthOptions,DateTime InactiveSinceDate){
            StoredProcedure sp=new StoredProcedure("aspnet_Profile_DeleteInactiveProfiles",this.Provider);
            sp.Command.AddParameter("ApplicationName",ApplicationName,DbType.String);
            sp.Command.AddParameter("ProfileAuthOptions",ProfileAuthOptions,DbType.Int32);
            sp.Command.AddParameter("InactiveSinceDate",InactiveSinceDate,DbType.DateTime);
            return sp;
        }
        public StoredProcedure aspnet_Profile_DeleteProfiles(string ApplicationName,string UserNames){
            StoredProcedure sp=new StoredProcedure("aspnet_Profile_DeleteProfiles",this.Provider);
            sp.Command.AddParameter("ApplicationName",ApplicationName,DbType.String);
            sp.Command.AddParameter("UserNames",UserNames,DbType.String);
            return sp;
        }
        public StoredProcedure aspnet_Profile_GetNumberOfInactiveProfiles(string ApplicationName,int ProfileAuthOptions,DateTime InactiveSinceDate){
            StoredProcedure sp=new StoredProcedure("aspnet_Profile_GetNumberOfInactiveProfiles",this.Provider);
            sp.Command.AddParameter("ApplicationName",ApplicationName,DbType.String);
            sp.Command.AddParameter("ProfileAuthOptions",ProfileAuthOptions,DbType.Int32);
            sp.Command.AddParameter("InactiveSinceDate",InactiveSinceDate,DbType.DateTime);
            return sp;
        }
        public StoredProcedure aspnet_Profile_GetProfiles(string ApplicationName,int ProfileAuthOptions,int PageIndex,int PageSize,string UserNameToMatch,DateTime InactiveSinceDate){
            StoredProcedure sp=new StoredProcedure("aspnet_Profile_GetProfiles",this.Provider);
            sp.Command.AddParameter("ApplicationName",ApplicationName,DbType.String);
            sp.Command.AddParameter("ProfileAuthOptions",ProfileAuthOptions,DbType.Int32);
            sp.Command.AddParameter("PageIndex",PageIndex,DbType.Int32);
            sp.Command.AddParameter("PageSize",PageSize,DbType.Int32);
            sp.Command.AddParameter("UserNameToMatch",UserNameToMatch,DbType.String);
            sp.Command.AddParameter("InactiveSinceDate",InactiveSinceDate,DbType.DateTime);
            return sp;
        }
        public StoredProcedure aspnet_Profile_GetProperties(string ApplicationName,string UserName,DateTime CurrentTimeUtc){
            StoredProcedure sp=new StoredProcedure("aspnet_Profile_GetProperties",this.Provider);
            sp.Command.AddParameter("ApplicationName",ApplicationName,DbType.String);
            sp.Command.AddParameter("UserName",UserName,DbType.String);
            sp.Command.AddParameter("CurrentTimeUtc",CurrentTimeUtc,DbType.DateTime);
            return sp;
        }
        public StoredProcedure aspnet_Profile_SetProperties(string ApplicationName,string PropertyNames,string PropertyValuesString,byte[] PropertyValuesBinary,string UserName,bool IsUserAnonymous,DateTime CurrentTimeUtc){
            StoredProcedure sp=new StoredProcedure("aspnet_Profile_SetProperties",this.Provider);
            sp.Command.AddParameter("ApplicationName",ApplicationName,DbType.String);
            sp.Command.AddParameter("PropertyNames",PropertyNames,DbType.String);
            sp.Command.AddParameter("PropertyValuesString",PropertyValuesString,DbType.String);
            sp.Command.AddParameter("PropertyValuesBinary",PropertyValuesBinary,DbType.Binary);
            sp.Command.AddParameter("UserName",UserName,DbType.String);
            sp.Command.AddParameter("IsUserAnonymous",IsUserAnonymous,DbType.Boolean);
            sp.Command.AddParameter("CurrentTimeUtc",CurrentTimeUtc,DbType.DateTime);
            return sp;
        }
        public StoredProcedure aspnet_RegisterSchemaVersion(string Feature,string CompatibleSchemaVersion,bool IsCurrentVersion,bool RemoveIncompatibleSchema){
            StoredProcedure sp=new StoredProcedure("aspnet_RegisterSchemaVersion",this.Provider);
            sp.Command.AddParameter("Feature",Feature,DbType.String);
            sp.Command.AddParameter("CompatibleSchemaVersion",CompatibleSchemaVersion,DbType.String);
            sp.Command.AddParameter("IsCurrentVersion",IsCurrentVersion,DbType.Boolean);
            sp.Command.AddParameter("RemoveIncompatibleSchema",RemoveIncompatibleSchema,DbType.Boolean);
            return sp;
        }
        public StoredProcedure aspnet_Roles_CreateRole(string ApplicationName,string RoleName){
            StoredProcedure sp=new StoredProcedure("aspnet_Roles_CreateRole",this.Provider);
            sp.Command.AddParameter("ApplicationName",ApplicationName,DbType.String);
            sp.Command.AddParameter("RoleName",RoleName,DbType.String);
            return sp;
        }
        public StoredProcedure aspnet_Roles_DeleteRole(string ApplicationName,string RoleName,bool DeleteOnlyIfRoleIsEmpty){
            StoredProcedure sp=new StoredProcedure("aspnet_Roles_DeleteRole",this.Provider);
            sp.Command.AddParameter("ApplicationName",ApplicationName,DbType.String);
            sp.Command.AddParameter("RoleName",RoleName,DbType.String);
            sp.Command.AddParameter("DeleteOnlyIfRoleIsEmpty",DeleteOnlyIfRoleIsEmpty,DbType.Boolean);
            return sp;
        }
        public StoredProcedure aspnet_Roles_GetAllRoles(string ApplicationName){
            StoredProcedure sp=new StoredProcedure("aspnet_Roles_GetAllRoles",this.Provider);
            sp.Command.AddParameter("ApplicationName",ApplicationName,DbType.String);
            return sp;
        }
        public StoredProcedure aspnet_Roles_RoleExists(string ApplicationName,string RoleName){
            StoredProcedure sp=new StoredProcedure("aspnet_Roles_RoleExists",this.Provider);
            sp.Command.AddParameter("ApplicationName",ApplicationName,DbType.String);
            sp.Command.AddParameter("RoleName",RoleName,DbType.String);
            return sp;
        }
        public StoredProcedure aspnet_Setup_RemoveAllRoleMembers(string name){
            StoredProcedure sp=new StoredProcedure("aspnet_Setup_RemoveAllRoleMembers",this.Provider);
            sp.Command.AddParameter("name",name,DbType.String);
            return sp;
        }
        public StoredProcedure aspnet_Setup_RestorePermissions(string name){
            StoredProcedure sp=new StoredProcedure("aspnet_Setup_RestorePermissions",this.Provider);
            sp.Command.AddParameter("name",name,DbType.String);
            return sp;
        }
        public StoredProcedure AspNet_SqlCachePollingStoredProcedure(){
            StoredProcedure sp=new StoredProcedure("AspNet_SqlCachePollingStoredProcedure",this.Provider);
            return sp;
        }
        public StoredProcedure AspNet_SqlCacheQueryRegisteredTablesStoredProcedure(){
            StoredProcedure sp=new StoredProcedure("AspNet_SqlCacheQueryRegisteredTablesStoredProcedure",this.Provider);
            return sp;
        }
        public StoredProcedure AspNet_SqlCacheRegisterTableStoredProcedure(string tableName){
            StoredProcedure sp=new StoredProcedure("AspNet_SqlCacheRegisterTableStoredProcedure",this.Provider);
            sp.Command.AddParameter("tableName",tableName,DbType.String);
            return sp;
        }
        public StoredProcedure AspNet_SqlCacheUnRegisterTableStoredProcedure(string tableName){
            StoredProcedure sp=new StoredProcedure("AspNet_SqlCacheUnRegisterTableStoredProcedure",this.Provider);
            sp.Command.AddParameter("tableName",tableName,DbType.String);
            return sp;
        }
        public StoredProcedure AspNet_SqlCacheUpdateChangeIdStoredProcedure(string tableName){
            StoredProcedure sp=new StoredProcedure("AspNet_SqlCacheUpdateChangeIdStoredProcedure",this.Provider);
            sp.Command.AddParameter("tableName",tableName,DbType.String);
            return sp;
        }
        public StoredProcedure aspnet_UnRegisterSchemaVersion(string Feature,string CompatibleSchemaVersion){
            StoredProcedure sp=new StoredProcedure("aspnet_UnRegisterSchemaVersion",this.Provider);
            sp.Command.AddParameter("Feature",Feature,DbType.String);
            sp.Command.AddParameter("CompatibleSchemaVersion",CompatibleSchemaVersion,DbType.String);
            return sp;
        }
        public StoredProcedure aspnet_Users_CreateUser(Guid ApplicationId,string UserName,bool IsUserAnonymous,DateTime LastActivityDate,Guid UserId){
            StoredProcedure sp=new StoredProcedure("aspnet_Users_CreateUser",this.Provider);
            sp.Command.AddParameter("ApplicationId",ApplicationId,DbType.Guid);
            sp.Command.AddParameter("UserName",UserName,DbType.String);
            sp.Command.AddParameter("IsUserAnonymous",IsUserAnonymous,DbType.Boolean);
            sp.Command.AddParameter("LastActivityDate",LastActivityDate,DbType.DateTime);
            sp.Command.AddParameter("UserId",UserId,DbType.Guid);
            return sp;
        }
        public StoredProcedure aspnet_Users_DeleteUser(string ApplicationName,string UserName,int TablesToDeleteFrom,int NumTablesDeletedFrom){
            StoredProcedure sp=new StoredProcedure("aspnet_Users_DeleteUser",this.Provider);
            sp.Command.AddParameter("ApplicationName",ApplicationName,DbType.String);
            sp.Command.AddParameter("UserName",UserName,DbType.String);
            sp.Command.AddParameter("TablesToDeleteFrom",TablesToDeleteFrom,DbType.Int32);
            sp.Command.AddParameter("NumTablesDeletedFrom",NumTablesDeletedFrom,DbType.Int32);
            return sp;
        }
        public StoredProcedure aspnet_UsersInRoles_AddUsersToRoles(string ApplicationName,string UserNames,string RoleNames,DateTime CurrentTimeUtc){
            StoredProcedure sp=new StoredProcedure("aspnet_UsersInRoles_AddUsersToRoles",this.Provider);
            sp.Command.AddParameter("ApplicationName",ApplicationName,DbType.String);
            sp.Command.AddParameter("UserNames",UserNames,DbType.String);
            sp.Command.AddParameter("RoleNames",RoleNames,DbType.String);
            sp.Command.AddParameter("CurrentTimeUtc",CurrentTimeUtc,DbType.DateTime);
            return sp;
        }
        public StoredProcedure aspnet_UsersInRoles_FindUsersInRole(string ApplicationName,string RoleName,string UserNameToMatch){
            StoredProcedure sp=new StoredProcedure("aspnet_UsersInRoles_FindUsersInRole",this.Provider);
            sp.Command.AddParameter("ApplicationName",ApplicationName,DbType.String);
            sp.Command.AddParameter("RoleName",RoleName,DbType.String);
            sp.Command.AddParameter("UserNameToMatch",UserNameToMatch,DbType.String);
            return sp;
        }
        public StoredProcedure aspnet_UsersInRoles_GetRolesForUser(string ApplicationName,string UserName){
            StoredProcedure sp=new StoredProcedure("aspnet_UsersInRoles_GetRolesForUser",this.Provider);
            sp.Command.AddParameter("ApplicationName",ApplicationName,DbType.String);
            sp.Command.AddParameter("UserName",UserName,DbType.String);
            return sp;
        }
        public StoredProcedure aspnet_UsersInRoles_GetUsersInRoles(string ApplicationName,string RoleName){
            StoredProcedure sp=new StoredProcedure("aspnet_UsersInRoles_GetUsersInRoles",this.Provider);
            sp.Command.AddParameter("ApplicationName",ApplicationName,DbType.String);
            sp.Command.AddParameter("RoleName",RoleName,DbType.String);
            return sp;
        }
        public StoredProcedure aspnet_UsersInRoles_IsUserInRole(string ApplicationName,string UserName,string RoleName){
            StoredProcedure sp=new StoredProcedure("aspnet_UsersInRoles_IsUserInRole",this.Provider);
            sp.Command.AddParameter("ApplicationName",ApplicationName,DbType.String);
            sp.Command.AddParameter("UserName",UserName,DbType.String);
            sp.Command.AddParameter("RoleName",RoleName,DbType.String);
            return sp;
        }
        public StoredProcedure aspnet_UsersInRoles_RemoveUsersFromRoles(string ApplicationName,string UserNames,string RoleNames){
            StoredProcedure sp=new StoredProcedure("aspnet_UsersInRoles_RemoveUsersFromRoles",this.Provider);
            sp.Command.AddParameter("ApplicationName",ApplicationName,DbType.String);
            sp.Command.AddParameter("UserNames",UserNames,DbType.String);
            sp.Command.AddParameter("RoleNames",RoleNames,DbType.String);
            return sp;
        }
        public StoredProcedure aspnet_WebEvent_LogEvent(string EventId,DateTime EventTimeUtc,DateTime EventTime,string EventType,decimal EventSequence,decimal EventOccurrence,int EventCode,int EventDetailCode,string Message,string ApplicationPath,string ApplicationVirtualPath,string MachineName,string RequestUrl,string ExceptionType,string Details){
            StoredProcedure sp=new StoredProcedure("aspnet_WebEvent_LogEvent",this.Provider);
            sp.Command.AddParameter("EventId",EventId,DbType.AnsiStringFixedLength);
            sp.Command.AddParameter("EventTimeUtc",EventTimeUtc,DbType.DateTime);
            sp.Command.AddParameter("EventTime",EventTime,DbType.DateTime);
            sp.Command.AddParameter("EventType",EventType,DbType.String);
            sp.Command.AddParameter("EventSequence",EventSequence,DbType.Decimal);
            sp.Command.AddParameter("EventOccurrence",EventOccurrence,DbType.Decimal);
            sp.Command.AddParameter("EventCode",EventCode,DbType.Int32);
            sp.Command.AddParameter("EventDetailCode",EventDetailCode,DbType.Int32);
            sp.Command.AddParameter("Message",Message,DbType.String);
            sp.Command.AddParameter("ApplicationPath",ApplicationPath,DbType.String);
            sp.Command.AddParameter("ApplicationVirtualPath",ApplicationVirtualPath,DbType.String);
            sp.Command.AddParameter("MachineName",MachineName,DbType.String);
            sp.Command.AddParameter("RequestUrl",RequestUrl,DbType.String);
            sp.Command.AddParameter("ExceptionType",ExceptionType,DbType.String);
            sp.Command.AddParameter("Details",Details,DbType.String);
            return sp;
        }
        public StoredProcedure Authenticate(string Login,string Password){
            StoredProcedure sp=new StoredProcedure("Authenticate",this.Provider);
            sp.Command.AddParameter("Login",Login,DbType.AnsiString);
            sp.Command.AddParameter("Password",Password,DbType.AnsiString);
            return sp;
        }
        public StoredProcedure ClearTables(){
            StoredProcedure sp=new StoredProcedure("ClearTables",this.Provider);
            return sp;
        }
        public StoredProcedure dt_addtosourcecontrol(string vchSourceSafeINI,string vchProjectName,string vchComment,string vchLoginName,string vchPassword){
            StoredProcedure sp=new StoredProcedure("dt_addtosourcecontrol",this.Provider);
            sp.Command.AddParameter("vchSourceSafeINI",vchSourceSafeINI,DbType.AnsiString);
            sp.Command.AddParameter("vchProjectName",vchProjectName,DbType.AnsiString);
            sp.Command.AddParameter("vchComment",vchComment,DbType.AnsiString);
            sp.Command.AddParameter("vchLoginName",vchLoginName,DbType.AnsiString);
            sp.Command.AddParameter("vchPassword",vchPassword,DbType.AnsiString);
            return sp;
        }
        public StoredProcedure dt_addtosourcecontrol_u(string vchSourceSafeINI,string vchProjectName,string vchComment,string vchLoginName,string vchPassword){
            StoredProcedure sp=new StoredProcedure("dt_addtosourcecontrol_u",this.Provider);
            sp.Command.AddParameter("vchSourceSafeINI",vchSourceSafeINI,DbType.String);
            sp.Command.AddParameter("vchProjectName",vchProjectName,DbType.String);
            sp.Command.AddParameter("vchComment",vchComment,DbType.String);
            sp.Command.AddParameter("vchLoginName",vchLoginName,DbType.String);
            sp.Command.AddParameter("vchPassword",vchPassword,DbType.String);
            return sp;
        }
        public StoredProcedure dt_adduserobject(){
            StoredProcedure sp=new StoredProcedure("dt_adduserobject",this.Provider);
            return sp;
        }
        public StoredProcedure dt_adduserobject_vcs(string vchProperty){
            StoredProcedure sp=new StoredProcedure("dt_adduserobject_vcs",this.Provider);
            sp.Command.AddParameter("vchProperty",vchProperty,DbType.AnsiString);
            return sp;
        }
        public StoredProcedure dt_checkinobject(string chObjectType,string vchObjectName,string vchComment,string vchLoginName,string vchPassword,int iVCSFlags,int iActionFlag,string txStream1,string txStream2,string txStream3){
            StoredProcedure sp=new StoredProcedure("dt_checkinobject",this.Provider);
            sp.Command.AddParameter("chObjectType",chObjectType,DbType.AnsiStringFixedLength);
            sp.Command.AddParameter("vchObjectName",vchObjectName,DbType.AnsiString);
            sp.Command.AddParameter("vchComment",vchComment,DbType.AnsiString);
            sp.Command.AddParameter("vchLoginName",vchLoginName,DbType.AnsiString);
            sp.Command.AddParameter("vchPassword",vchPassword,DbType.AnsiString);
            sp.Command.AddParameter("iVCSFlags",iVCSFlags,DbType.Int32);
            sp.Command.AddParameter("iActionFlag",iActionFlag,DbType.Int32);
            sp.Command.AddParameter("txStream1",txStream1,DbType.AnsiString);
            sp.Command.AddParameter("txStream2",txStream2,DbType.AnsiString);
            sp.Command.AddParameter("txStream3",txStream3,DbType.AnsiString);
            return sp;
        }
        public StoredProcedure dt_checkinobject_u(string chObjectType,string vchObjectName,string vchComment,string vchLoginName,string vchPassword,int iVCSFlags,int iActionFlag,string txStream1,string txStream2,string txStream3){
            StoredProcedure sp=new StoredProcedure("dt_checkinobject_u",this.Provider);
            sp.Command.AddParameter("chObjectType",chObjectType,DbType.AnsiStringFixedLength);
            sp.Command.AddParameter("vchObjectName",vchObjectName,DbType.String);
            sp.Command.AddParameter("vchComment",vchComment,DbType.String);
            sp.Command.AddParameter("vchLoginName",vchLoginName,DbType.String);
            sp.Command.AddParameter("vchPassword",vchPassword,DbType.String);
            sp.Command.AddParameter("iVCSFlags",iVCSFlags,DbType.Int32);
            sp.Command.AddParameter("iActionFlag",iActionFlag,DbType.Int32);
            sp.Command.AddParameter("txStream1",txStream1,DbType.AnsiString);
            sp.Command.AddParameter("txStream2",txStream2,DbType.AnsiString);
            sp.Command.AddParameter("txStream3",txStream3,DbType.AnsiString);
            return sp;
        }
        public StoredProcedure dt_checkoutobject(string chObjectType,string vchObjectName,string vchComment,string vchLoginName,string vchPassword,int iVCSFlags,int iActionFlag){
            StoredProcedure sp=new StoredProcedure("dt_checkoutobject",this.Provider);
            sp.Command.AddParameter("chObjectType",chObjectType,DbType.AnsiStringFixedLength);
            sp.Command.AddParameter("vchObjectName",vchObjectName,DbType.AnsiString);
            sp.Command.AddParameter("vchComment",vchComment,DbType.AnsiString);
            sp.Command.AddParameter("vchLoginName",vchLoginName,DbType.AnsiString);
            sp.Command.AddParameter("vchPassword",vchPassword,DbType.AnsiString);
            sp.Command.AddParameter("iVCSFlags",iVCSFlags,DbType.Int32);
            sp.Command.AddParameter("iActionFlag",iActionFlag,DbType.Int32);
            return sp;
        }
        public StoredProcedure dt_checkoutobject_u(string chObjectType,string vchObjectName,string vchComment,string vchLoginName,string vchPassword,int iVCSFlags,int iActionFlag){
            StoredProcedure sp=new StoredProcedure("dt_checkoutobject_u",this.Provider);
            sp.Command.AddParameter("chObjectType",chObjectType,DbType.AnsiStringFixedLength);
            sp.Command.AddParameter("vchObjectName",vchObjectName,DbType.String);
            sp.Command.AddParameter("vchComment",vchComment,DbType.String);
            sp.Command.AddParameter("vchLoginName",vchLoginName,DbType.String);
            sp.Command.AddParameter("vchPassword",vchPassword,DbType.String);
            sp.Command.AddParameter("iVCSFlags",iVCSFlags,DbType.Int32);
            sp.Command.AddParameter("iActionFlag",iActionFlag,DbType.Int32);
            return sp;
        }
        public StoredProcedure dt_displayoaerror(int iObject,int iresult){
            StoredProcedure sp=new StoredProcedure("dt_displayoaerror",this.Provider);
            sp.Command.AddParameter("iObject",iObject,DbType.Int32);
            sp.Command.AddParameter("iresult",iresult,DbType.Int32);
            return sp;
        }
        public StoredProcedure dt_displayoaerror_u(int iObject,int iresult){
            StoredProcedure sp=new StoredProcedure("dt_displayoaerror_u",this.Provider);
            sp.Command.AddParameter("iObject",iObject,DbType.Int32);
            sp.Command.AddParameter("iresult",iresult,DbType.Int32);
            return sp;
        }
        public StoredProcedure dt_droppropertiesbyid(int id,string property){
            StoredProcedure sp=new StoredProcedure("dt_droppropertiesbyid",this.Provider);
            sp.Command.AddParameter("id",id,DbType.Int32);
            sp.Command.AddParameter("property",property,DbType.AnsiString);
            return sp;
        }
        public StoredProcedure dt_dropuserobjectbyid(int id){
            StoredProcedure sp=new StoredProcedure("dt_dropuserobjectbyid",this.Provider);
            sp.Command.AddParameter("id",id,DbType.Int32);
            return sp;
        }
        public StoredProcedure dt_generateansiname(string name){
            StoredProcedure sp=new StoredProcedure("dt_generateansiname",this.Provider);
            sp.Command.AddParameter("name",name,DbType.AnsiString);
            return sp;
        }
        public StoredProcedure dt_getobjwithprop(string property,string value){
            StoredProcedure sp=new StoredProcedure("dt_getobjwithprop",this.Provider);
            sp.Command.AddParameter("property",property,DbType.AnsiString);
            sp.Command.AddParameter("value",value,DbType.AnsiString);
            return sp;
        }
        public StoredProcedure dt_getobjwithprop_u(string property,string uvalue){
            StoredProcedure sp=new StoredProcedure("dt_getobjwithprop_u",this.Provider);
            sp.Command.AddParameter("property",property,DbType.AnsiString);
            sp.Command.AddParameter("uvalue",uvalue,DbType.String);
            return sp;
        }
        public StoredProcedure dt_getpropertiesbyid(int id,string property){
            StoredProcedure sp=new StoredProcedure("dt_getpropertiesbyid",this.Provider);
            sp.Command.AddParameter("id",id,DbType.Int32);
            sp.Command.AddParameter("property",property,DbType.AnsiString);
            return sp;
        }
        public StoredProcedure dt_getpropertiesbyid_u(int id,string property){
            StoredProcedure sp=new StoredProcedure("dt_getpropertiesbyid_u",this.Provider);
            sp.Command.AddParameter("id",id,DbType.Int32);
            sp.Command.AddParameter("property",property,DbType.AnsiString);
            return sp;
        }
        public StoredProcedure dt_getpropertiesbyid_vcs(int id,string property,string value){
            StoredProcedure sp=new StoredProcedure("dt_getpropertiesbyid_vcs",this.Provider);
            sp.Command.AddParameter("id",id,DbType.Int32);
            sp.Command.AddParameter("property",property,DbType.AnsiString);
            sp.Command.AddParameter("value",value,DbType.AnsiString);
            return sp;
        }
        public StoredProcedure dt_getpropertiesbyid_vcs_u(int id,string property,string value){
            StoredProcedure sp=new StoredProcedure("dt_getpropertiesbyid_vcs_u",this.Provider);
            sp.Command.AddParameter("id",id,DbType.Int32);
            sp.Command.AddParameter("property",property,DbType.AnsiString);
            sp.Command.AddParameter("value",value,DbType.String);
            return sp;
        }
        public StoredProcedure dt_isundersourcecontrol(string vchLoginName,string vchPassword,int iWhoToo){
            StoredProcedure sp=new StoredProcedure("dt_isundersourcecontrol",this.Provider);
            sp.Command.AddParameter("vchLoginName",vchLoginName,DbType.AnsiString);
            sp.Command.AddParameter("vchPassword",vchPassword,DbType.AnsiString);
            sp.Command.AddParameter("iWhoToo",iWhoToo,DbType.Int32);
            return sp;
        }
        public StoredProcedure dt_isundersourcecontrol_u(string vchLoginName,string vchPassword,int iWhoToo){
            StoredProcedure sp=new StoredProcedure("dt_isundersourcecontrol_u",this.Provider);
            sp.Command.AddParameter("vchLoginName",vchLoginName,DbType.String);
            sp.Command.AddParameter("vchPassword",vchPassword,DbType.String);
            sp.Command.AddParameter("iWhoToo",iWhoToo,DbType.Int32);
            return sp;
        }
        public StoredProcedure dt_removefromsourcecontrol(){
            StoredProcedure sp=new StoredProcedure("dt_removefromsourcecontrol",this.Provider);
            return sp;
        }
        public StoredProcedure dt_setpropertybyid(int id,string property,string value,byte[] lvalue){
            StoredProcedure sp=new StoredProcedure("dt_setpropertybyid",this.Provider);
            sp.Command.AddParameter("id",id,DbType.Int32);
            sp.Command.AddParameter("property",property,DbType.AnsiString);
            sp.Command.AddParameter("value",value,DbType.AnsiString);
            sp.Command.AddParameter("lvalue",lvalue,DbType.Binary);
            return sp;
        }
        public StoredProcedure dt_setpropertybyid_u(int id,string property,string uvalue,byte[] lvalue){
            StoredProcedure sp=new StoredProcedure("dt_setpropertybyid_u",this.Provider);
            sp.Command.AddParameter("id",id,DbType.Int32);
            sp.Command.AddParameter("property",property,DbType.AnsiString);
            sp.Command.AddParameter("uvalue",uvalue,DbType.String);
            sp.Command.AddParameter("lvalue",lvalue,DbType.Binary);
            return sp;
        }
        public StoredProcedure dt_validateloginparams(string vchLoginName,string vchPassword){
            StoredProcedure sp=new StoredProcedure("dt_validateloginparams",this.Provider);
            sp.Command.AddParameter("vchLoginName",vchLoginName,DbType.AnsiString);
            sp.Command.AddParameter("vchPassword",vchPassword,DbType.AnsiString);
            return sp;
        }
        public StoredProcedure dt_validateloginparams_u(string vchLoginName,string vchPassword){
            StoredProcedure sp=new StoredProcedure("dt_validateloginparams_u",this.Provider);
            sp.Command.AddParameter("vchLoginName",vchLoginName,DbType.String);
            sp.Command.AddParameter("vchPassword",vchPassword,DbType.String);
            return sp;
        }
        public StoredProcedure dt_vcsenabled(){
            StoredProcedure sp=new StoredProcedure("dt_vcsenabled",this.Provider);
            return sp;
        }
        public StoredProcedure dt_verstamp006(){
            StoredProcedure sp=new StoredProcedure("dt_verstamp006",this.Provider);
            return sp;
        }
        public StoredProcedure dt_whocheckedout(string chObjectType,string vchObjectName,string vchLoginName,string vchPassword){
            StoredProcedure sp=new StoredProcedure("dt_whocheckedout",this.Provider);
            sp.Command.AddParameter("chObjectType",chObjectType,DbType.AnsiStringFixedLength);
            sp.Command.AddParameter("vchObjectName",vchObjectName,DbType.AnsiString);
            sp.Command.AddParameter("vchLoginName",vchLoginName,DbType.AnsiString);
            sp.Command.AddParameter("vchPassword",vchPassword,DbType.AnsiString);
            return sp;
        }
        public StoredProcedure dt_whocheckedout_u(string chObjectType,string vchObjectName,string vchLoginName,string vchPassword){
            StoredProcedure sp=new StoredProcedure("dt_whocheckedout_u",this.Provider);
            sp.Command.AddParameter("chObjectType",chObjectType,DbType.AnsiStringFixedLength);
            sp.Command.AddParameter("vchObjectName",vchObjectName,DbType.String);
            sp.Command.AddParameter("vchLoginName",vchLoginName,DbType.String);
            sp.Command.AddParameter("vchPassword",vchPassword,DbType.String);
            return sp;
        }
        public StoredProcedure DynamicInsert(string TableName,string Fields,string Values){
            StoredProcedure sp=new StoredProcedure("DynamicInsert",this.Provider);
            sp.Command.AddParameter("TableName",TableName,DbType.AnsiString);
            sp.Command.AddParameter("Fields",Fields,DbType.AnsiString);
            sp.Command.AddParameter("Values",Values,DbType.AnsiString);
            return sp;
        }
        public StoredProcedure DynamicSelect(string SelectFields,string FromTables,string WhereClause,string OrderByClause,string GroupByClause){
            StoredProcedure sp=new StoredProcedure("DynamicSelect",this.Provider);
            sp.Command.AddParameter("SelectFields",SelectFields,DbType.AnsiString);
            sp.Command.AddParameter("FromTables",FromTables,DbType.AnsiString);
            sp.Command.AddParameter("WhereClause",WhereClause,DbType.AnsiString);
            sp.Command.AddParameter("OrderByClause",OrderByClause,DbType.AnsiString);
            sp.Command.AddParameter("GroupByClause",GroupByClause,DbType.AnsiString);
            return sp;
        }
        public StoredProcedure Report(string WhereClause){
            StoredProcedure sp=new StoredProcedure("Report",this.Provider);
            sp.Command.AddParameter("WhereClause",WhereClause,DbType.AnsiString);
            return sp;
        }
	
	}
	
}
 